package com.dinghui.salary.mapper;

import com.dinghui.salary.my.mapper.MyMapper;
import com.dinghui.salary.pojo.Page;
import com.dinghui.salary.pojo.Salary;
import com.dinghui.salary.pojo.vo.StatisticsVO;
import com.dinghui.salary.pojo.vo.YearMonthStatisticsVO;
import com.dinghui.salary.pojo.vo.YearStatisticsVO;
import org.apache.ibatis.annotations.Param;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

public interface SalaryMapper extends MyMapper<Salary> {

    List<YearMonthStatisticsVO> selectSalaryStatisticsByYearAndMonth();

    List<YearStatisticsVO> selectSalaryStatisticsByYear();

    List<Salary> getAll(Page dto);

    StatisticsVO selectStatisticsByTableName(String tableName);

    ArrayList<HashMap> selectSalaryList(@Param("tableName") String tableName,@Param("idNumber") String idNumber,@Param("name") String name);

    ArrayList<HashMap> FindAlls(@Param("tableName") String tableName,@Param("yearMonth") String yearMonth);
}